﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Xiaov.SmartWeb.Infrastructure.ExtMethod;

namespace Xiaov.SmartWeb.Application.PluginSrc.StatisticalSystem
{
    public partial class UpdateTbsj : System.Web.UI.Page
    {
        public string TableName { get; set; }
        public string Year { get; set; }
        public string Month { get; set; }
        public string DWBM { get; set; }
        public string ZBBM { get; set; }
        protected void Page_Load(object sender, EventArgs e)
        {
            TableName = Request.Form["tn"].ToRequestString();
            Year = Request.Form["year"].ToRequestString();
            Month = Request.Form["month"].ToRequestString();
            DWBM = Request.Form["dwbm"].ToRequestString();
            string sql = "update bbtbqk t set t.tbsj=to_date('" + DateTime.Now.ToString() + "','yyyy-mm-dd hh24:mi:ss') where bbbm='" + TableName + "' and dwbm='" + DWBM + "' and nf=" + Year + " and yf=" + Month + " and tbsj is null ";
            Maticsoft.DBUtility.DbHelperOra.ExecuteSql(sql);
        }

    }
}